SyStaff_Proxy

EntityType | Independent
Logical Entity Name | SyStaff_Proxy
Default Table Name | SyStaff_Proxy
Logical Only | NO
Owner | dbo
Definition |
Note |

SyStaff_Proxy Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
SyStaff_ProxyID |  | INTEGER | NO |
RecordID |  | INTEGER | NO |
OldCode |  | VARCHAR(255) | YES |
NewCode |  | VARCHAR(255) | YES |
OldSyCampusGrpID |  | INTEGER | YES |
NewSyCampusGrpID |  | INTEGER | YES |
OldPassword |  | VARCHAR(75) | YES |
NewPassword |  | VARCHAR(75) | YES |
OldDescrip |  | VARCHAR(50) | YES |
NewDescrip |  | VARCHAR(50) | YES |
OldTitle |  | CHAR(10) | YES |
NewTitle |  | CHAR(10) | YES |
OldLastName |  | VARCHAR(25) | YES |
NewLastName |  | VARCHAR(25) | YES |
OldFirstName |  | VARCHAR(25) | YES |
NewFirstName |  | VARCHAR(25) | YES |
OldMI |  | CHAR(1) | YES |
NewMI |  | CHAR(1) | YES |
OldSuffix |  | VARCHAR(10) | YES |
NewSuffix |  | VARCHAR(10) | YES |
OldAddr1 |  | VARCHAR(255) | YES |
NewAddr1 |  | VARCHAR(255) | YES |
OldAddr2 |  | VARCHAR(35) | YES |
NewAddr2 |  | VARCHAR(35) | YES |
OldCity |  | VARCHAR(25) | YES |
NewCity |  | VARCHAR(25) | YES |
OldState |  | CHAR(2) | YES |
NewState |  | CHAR(2) | YES |
OldZip |  | CHAR(10) | YES |
NewZip |  | CHAR(10) | YES |
OldSSN |  | CHAR(11) | YES |
NewSSN |  | CHAR(11) | YES |
OldWorkAddr1 |  | VARCHAR(255) | YES |
NewWorkAddr1 |  | VARCHAR(255) | YES |
OldWorkAddr2 |  | VARCHAR(35) | YES |
NewWorkAddr2 |  | VARCHAR(35) | YES |
OldWorkCity |  | VARCHAR(25) | YES |
NewWorkCity |  | VARCHAR(25) | YES |
OldWorkState |  | CHAR(2) | YES |
NewWorkState |  | CHAR(2) | YES |
OldWorkZip |  | CHAR(10) | YES |
NewWorkZip |  | CHAR(10) | YES |
OldPhone |  | CHAR(16) | YES |
NewPhone |  | CHAR(16) | YES |
OldExt |  | CHAR(6) | YES |
NewExt |  | CHAR(6) | YES |
OldHomePhone |  | CHAR(16) | YES |
NewHomePhone |  | CHAR(16) | YES |
OldDateHired |  | DATETIME | YES |
NewDateHired |  | DATETIME | YES |
OldPayRate |  | MONEY(19, 4) | YES |
NewPayRate |  | MONEY(19, 4) | YES |
OldPayType |  | CHAR(1) | YES |
NewPayType |  | CHAR(1) | YES |
OldDegree |  | VARCHAR(30) | YES |
NewDegree |  | VARCHAR(30) | YES |
OldCertifications |  | VARCHAR(60) | YES |
NewCertifications |  | VARCHAR(60) | YES |
OldPosition |  | VARCHAR(50) | YES |
NewPosition |  | VARCHAR(50) | YES |
OldDepartment |  | CHAR(10) | YES |
NewDepartment |  | CHAR(10) | YES |
OldOverrideMaxClass |  | BIT | YES |
NewOverrideMaxClass |  | BIT | YES |
OldShowDefaultatStartup |  | BIT | YES |
NewShowDefaultatStartup |  | BIT | YES |
OldAllowGlobalSearch |  | BIT | YES |
NewAllowGlobalSearch |  | BIT | YES |
OldAllowAutoCMActivities |  | BIT | YES |
NewAllowAutoCMActivities |  | BIT | YES |
OldShowCMatStartUp |  | BIT | YES |
NewShowCMatStartUp |  | BIT | YES |
Oldemail |  | VARCHAR(50) | YES |
Newemail |  | VARCHAR(50) | YES |
OldSaveStudentList |  | BIT | YES |
NewSaveStudentList |  | BIT | YES |
OldDefaultModule |  | CHAR(2) | YES |
NewDefaultModule |  | CHAR(2) | YES |
OldReportDefault |  | CHAR(1) | YES |
NewReportDefault |  | CHAR(1) | YES |
OldSyCampusID |  | INTEGER | YES |
NewSyCampusID |  | INTEGER | YES |
OldAdTermID |  | INTEGER | YES |
NewAdTermID |  | INTEGER | YES |
OldFaYearID |  | CHAR(2) | YES |
NewFaYearID |  | CHAR(2) | YES |
OldViewToolBar |  | BIT | YES |
NewViewToolBar |  | BIT | YES |
OldViewListBar |  | BIT | YES |
NewViewListBar |  | BIT | YES |
OldCmStudListInclude |  | VARCHAR(1000) | YES |
NewCmStudListInclude |  | VARCHAR(1000) | YES |
OldCmStudListShow |  | VARCHAR(255) | YES |
NewCmStudListShow |  | VARCHAR(255) | YES |
OldAllowCustomSearch |  | BIT | YES |
NewAllowCustomSearch |  | BIT | YES |
OldSearchResults |  | VARCHAR(2000) | YES |
NewSearchResults |  | VARCHAR(2000) | YES |
OldSystemCode |  | BIT | YES |
NewSystemCode |  | BIT | YES |
OldActive |  | BIT | YES |
NewActive |  | BIT | YES |
OldPreReq |  | BIT | YES |
NewPreReq |  | BIT | YES |
OldTest |  | BIT | YES |
NewTest |  | BIT | YES |
OldAmrepTypeID |  | INTEGER | YES |
NewAmrepTypeID |  | INTEGER | YES |
OldCmPolicyID |  | INTEGER | YES |
NewCmPolicyID |  | INTEGER | YES |
OldCheckConflicts |  | BIT | YES |
NewCheckConflicts |  | BIT | YES |
OldSelectReportServer |  | BIT | YES |
NewSelectReportServer |  | BIT | YES |
OldComments |  | VARCHAR(3000) | YES |
NewComments |  | VARCHAR(3000) | YES |
Oldemail_ReplyTo |  | VARCHAR(50) | YES |
Newemail_ReplyTo |  | VARCHAR(50) | YES |
OldSyCountryID |  | INTEGER | YES |
NewSyCountryID |  | INTEGER | YES |
OldSyWorkCountryID |  | INTEGER | YES |
NewSyWorkCountryID |  | INTEGER | YES |
OldOverrideStatusChangeDays |  | BIT | YES |
NewOverrideStatusChangeDays |  | BIT | YES |
OldDefaultReportWizard |  | BIT | YES |
NewDefaultReportWizard |  | BIT | YES |
OldOverrideCloseTerm |  | BIT | YES |
NewOverrideCloseTerm |  | BIT | YES |
OldAllowEditAdvisor |  | BIT | YES |
NewAllowEditAdvisor |  | BIT | YES |
OldUseToolbar |  | BIT | YES |
NewUseToolbar |  | BIT | YES |
OldOverrideTransferOptions |  | BIT | YES |
NewOverrideTransferOptions |  | BIT | YES |
OldAllowAccessTranEnroll |  | BIT | YES |
NewAllowAccessTranEnroll |  | BIT | YES |
OldAllowAccessTranCampus |  | BIT | YES |
NewAllowAccessTranCampus |  | BIT | YES |
OldAllowAccessTranEnrollCampus |  | BIT | YES |
NewAllowAccessTranEnrollCampus |  | BIT | YES |
OldAllowAccesschange |  | BIT | YES |
NewAllowAccesschange |  | BIT | YES |
OldOverrideExecutiveReportOptions |  | BIT | YES |
NewOverrideExecutiveReportOptions |  | BIT | YES |
OldAllowShowAll |  | BIT | YES |
NewAllowShowAll |  | BIT | YES |
OldLocked |  | BIT | YES |
NewLocked |  | BIT | YES |
OldPasswordExpiration |  | DATETIME | YES |
NewPasswordExpiration |  | DATETIME | YES |
OldSyPasswordProfileID |  | INTEGER | YES |
NewSyPasswordProfileID |  | INTEGER | YES |
OldDropStatusMessageBox |  | BIT | YES |
NewDropStatusMessageBox |  | BIT | YES |
OldKey |  | VARCHAR(30) | YES |
NewKey |  | VARCHAR(30) | YES |
OldOfficeNumber |  | VARCHAR(20) | YES |
NewOfficeNumber |  | VARCHAR(20) | YES |
OldAllowRegGroupOverride |  | BIT | YES |
NewAllowRegGroupOverride |  | BIT | YES |
OldCmDocumentPolicyID |  | INTEGER | YES |
NewCmDocumentPolicyID |  | INTEGER | YES |
OldCashier |  | BIT | YES |
NewCashier |  | BIT | YES |
OldAllowMultiCampGrps |  | INTEGER | YES |
NewAllowMultiCampGrps |  | INTEGER | YES |
OldCellPhone |  | CHAR(16) | YES |
NewCellPhone |  | CHAR(16) | YES |
OldWorkFaxPhone |  | CHAR(16) | YES |
NewWorkFaxPhone |  | CHAR(16) | YES |
OldAllowDuplicateEmpOverride |  | BIT | YES |
NewAllowDuplicateEmpOverride |  | BIT | YES |
OldUserLevelOverrideAccess |  | BIT | YES |
NewUserLevelOverrideAccess |  | BIT | YES |
OldAllowPrimaryContactSecurity |  | BIT | YES |
NewAllowPrimaryContactSecurity |  | BIT | YES |
OldCreatedInLMS |  | BIT | YES |
NewCreatedInLMS |  | BIT | YES |
OldOverrideAuditDesgDdln |  | BIT | YES |
NewOverrideAuditDesgDdln |  | BIT | YES |
OldSyModuleID |  | INTEGER | YES |
NewSyModuleID |  | INTEGER | YES |
OldAllowOverrideCODChangeStatus |  | BIT | YES |
NewAllowOverrideCODChangeStatus |  | BIT | YES |
OldAllowRebuildTermSummaryRelationships |  | BIT | YES |
NewAllowRebuildTermSummaryRelationships |  | BIT | YES |
OldAllowCollegeAdditionSecurity |  | BIT | YES |
NewAllowCollegeAdditionSecurity |  | BIT | YES |
OldAllowCourseAdditionSecurity |  | BIT | YES |
NewAllowCourseAdditionSecurity |  | BIT | YES |
OldAllowTranscriptHoldGroupOverride |  | BIT | YES |
NewAllowTranscriptHoldGroupOverride |  | BIT | YES |
OldAllowJobTypeEditingSecurity |  | BIT | YES |
NewAllowJobTypeEditingSecurity |  | BIT | YES |
OldAllowReportingSSN |  | BIT | YES |
NewAllowReportingSSN |  | BIT | YES |
OldEmployeeNumber |  | VARCHAR(20) | YES |
NewEmployeeNumber |  | VARCHAR(20) | YES |
OldAllowAssociateEmployerOtherCampus |  | BIT | YES |
NewAllowAssociateEmployerOtherCampus |  | BIT | YES |
OldAllowCourseReassign |  | BIT | YES |
NewAllowCourseReassign |  | BIT | YES |
OldAllowOverrideSAPStatus |  | BIT | YES |
NewAllowOverrideSAPStatus |  | BIT | YES |
OldAllowDisbDateEdit |  | BIT | YES |
NewAllowDisbDateEdit |  | BIT | YES |
OldOverrideInstructorCourseAssociation |  | BIT | YES |
NewOverrideInstructorCourseAssociation |  | BIT | YES |
OldAllowCommonLineHoldRelease |  | BIT | YES |
NewAllowCommonLineHoldRelease |  | BIT | YES |
OldAllowPrintChecksEditComment |  | BIT | YES |
NewAllowPrintChecksEditComment |  | BIT | YES |
OldEditExceptionDetails |  | BIT | YES |
NewEditExceptionDetails |  | BIT | YES |
OldAllowOverrideSAPPartialTerm |  | BIT | YES |
NewAllowOverrideSAPPartialTerm |  | BIT | YES |
OldOverrideSapDefinedDates |  | BIT | YES |
NewOverrideSapDefinedDates |  | BIT | YES |
OldOverrideLockedTermSequence |  | BIT | YES |
NewOverrideLockedTermSequence |  | BIT | YES |
OldAllowWaiveDegreeAudit |  | BIT | YES |
NewAllowWaiveDegreeAudit |  | BIT | YES |
OldOverrideCourseComparison |  | BIT | YES |
NewOverrideCourseComparison |  | BIT | YES |
OldAllowManualRefundCalculation |  | BIT | YES |
NewAllowManualRefundCalculation |  | BIT | YES |
OldAllowOverrideRegistrationHold |  | BIT | YES |
NewAllowOverrideRegistrationHold |  | BIT | YES |
OldAllowFaHoldGroupOverride |  | BIT | YES |
NewAllowFaHoldGroupOverride |  | BIT | YES |
OldAllowFeeSchedModification |  | BIT | YES |
NewAllowFeeSchedModification |  | BIT | YES |
OldAllowBatchOverride |  | BIT | YES |
NewAllowBatchOverride |  | BIT | YES |
OldOverrideMaxClassUserCampuses |  | BIT | YES |
NewOverrideMaxClassUserCampuses |  | BIT | YES |
UserID |  | INTEGER | NO |
DateAdded |  | DATETIME | NO |
OldAllowOverrideRegistrationLocks |  | BIT | YES |
NewAllowOverrideRegistrationLocks |  | BIT | YES |
OldAllowRetakeFeeWaiver |  | BIT | YES |
NewAllowRetakeFeeWaiver |  | BIT | YES |
OldAllowPreReqCoReqOverrideForDropUnreg |  | BIT | YES |
NewAllowPreReqCoReqOverrideForDropUnreg |  | BIT | YES |
OldAllowUserLDWOverride |  | BIT | YES |
NewAllowUserLDWOverride |  | BIT | YES |
OldAllowHousingPeriodDateEdit |  | BIT | YES |
NewAllowHousingPeriodDateEdit |  | BIT | YES |
OldOverrideExpDeadlineDate |  | BIT | YES |
NewOverrideExpDeadlineDate |  | BIT | YES |
OldAllowOverrideTransferCreditApproval |  | BIT | YES |
NewAllowOverrideTransferCreditApproval |  | BIT | YES |
OldAllowDeleteUnbilledChargesLease |  | BIT | YES |
NewAllowDeleteUnbilledChargesLease |  | BIT | YES |
OldAllowDeleteBilledChargesLease |  | BIT | YES |
NewAllowDeleteBilledChargesLease |  | BIT | YES |
OldPreventManualBilling |  | BIT | YES |
NewPreventManualBilling |  | BIT | YES |
OldAllowOverrideLeaseDate |  | BIT | YES |
NewAllowOverrideLeaseDate |  | BIT | YES |
OldAllowOverrideRoomMaxCapacity |  | BIT | YES |
NewAllowOverrideRoomMaxCapacity |  | BIT | YES |
OldOverrideSapPPDefinedDates |  | BIT | YES |
NewOverrideSapPPDefinedDates |  | BIT | YES |
OldAllowOverrideMaxWaitList |  | BIT | YES |
NewAllowOverrideMaxWaitList |  | BIT | YES |
OldIsAutomatedUser |  | BIT | YES |
NewIsAutomatedUser |  | BIT | YES |
OldAllowDateExclusion |  | BIT | YES |
NewAllowDateExclusion |  | BIT | YES |
OldAllowDPAFulfill |  | BIT | YES |
NewAllowDPAFulfill |  | BIT | YES |
OldAllowSSNUI |  | BIT | YES |
NewAllowSSNUI |  | BIT | YES |
OldAllowAccessMasterCourseProgOverride |  | BIT | YES |
NewAllowAccessMasterCourseProgOverride |  | BIT | YES |

SyStaff_Proxy Keys

Key Name | Key Type | Keys
PK_SyStaff_Proxy_SyStaff_ProxyID | PrimaryKey | SyStaff_ProxyID

SyStaff_Proxy Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

SyStaff_Proxy Check Constraints

Check Constraint Name | CheckConstraint

SyStaff_Proxy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SyStaff_Proxy | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyStaff_Proxy | NO |  |  |

SyStaff_Proxy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

SyStaff_Proxy Data Movement Rules

Name | Type | Rule Text/Value